1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Shower Gel Bathroom Spy Camera HD 1080P DVR Motion Detection Remote Control On' at line 3
in:
[select count(p.products_id) as total FROM products p, products_description pd WHERE p.products_status = 1
AND p.products_id = pd.products_id
AND pd.language_id = 1 and ( pd.products_name LIKE '%bathspycamera.com Men's Shower Gel Bathroom Spy Camera HD 1080P DVR Motion Detection Remote Control On/Off Description: In so many kinds of hidden cameras%'
OR p.products_model
LIKE '%bathspycamera.com Men's Shower Gel Bathroom Spy Camera HD 1080P DVR Motion Detection Remote Control On/Off Description: In so many kinds of hidden cameras%') ]